Summary report of shootings(2018)

Shootings-2018.csv contains every single incident of United States in 2018. From the data set, we can tell these following things.

As whole, 340 shootings occured in United States in 2018, and these indidents killed 373 people. The most impacted city was Chicago, the number of killed people is 13 and 122 people got injured. This time, the impact was calculated by following equasion.

impact = num_killed * 3 + num_injured

As a state level, the most dangerous state is California. The impact value was 286.(death: 50, injuries: 136)

Summary Table

Summary Table is as following.

state sum_killed sum_injured sum_impact mean_impact
Alabama 12 55 91 6.500000
Arizona 4 5 17 8.500000
Arkansas 7 17 38 6.333333
California 50 136 286 8.171429
Colorado 9 27 54 6.750000
Connecticut 0 8 8 4.000000
Delaware 5 0 15 15.000000
District of Columbia 2 23 29 4.833333
Florida 48 132 276 9.200000
Georgia 3 33 42 5.250000
Illinois 21 150 213 6.085714
Indiana 10 27 57 7.125000
Kansas 1 11 14 7.000000
Kentucky 7 25 46 11.500000
Louisiana 15 50 95 7.307692
Maryland 13 31 70 7.777778
Massachusetts 0 4 4 4.000000
Michigan 10 28 58 7.250000
Minnesota 1 14 17 5.666667
Mississippi 1 17 20 6.666667
Missouri 12 52 88 6.285714
Nebraska 1 16 19 6.333333
Nevada 3 15 24 6.000000
New Jersey 4 54 66 6.600000
New Mexico 5 4 19 9.500000
New York 5 53 68 5.230769
North Carolina 14 37 79 7.181818
Ohio 13 46 85 7.727273
Oklahoma 2 19 25 5.000000
Pennsylvania 35 63 168 8.842105
South Carolina 5 19 34 8.500000
Tennessee 19 68 125 6.944444
Texas 29 62 149 9.312500
Utah 0 4 4 4.000000
Virginia 2 17 23 5.750000
Washington 4 9 21 7.000000
Wisconsin 1 16 19 4.750000

From this table, It seems that Califolnia, Florida and Illinois are three the most impacted states. However, these states have large population, so we cannot decide that these states are dangerous. New York has also large population but its impact value is small.

Description of a particular incident

The most impacted incident was Pompano Beach (Parkland) in Florida on February 14, 2018. The number of died people were 17 and 17 got injured. The impact of the shooting was very huge and have reverberated far beyond school, Marjory Stoneman Douglas High in Parkland, Fla., as schools around the nation closed Friday, or canceled activities after receiving threats. A teacher in Denver said she moved items from a closet in her classroom “to make more space for 9-year-olds to hide.”

from New York Times, ‘How Did This Happen?’: Grief and Fury After Florida Shooting

An interactive map

This is an interactive map. When your mouse is on the marker, it shows the number of victims, and when you click it, it shows the date incident occured.

A plot of your choice

This chart shows the number of victims of each state. As you can see, Califolnia, Florida and Illinois are have huge victims. The main reason for this is these states have large population. However, New York has few victims while it has a large population, so we think that New York is relatively safe state. About death rete, Pennsylvania is very high.